What are the different types of Sql Statement?
1597
04-May-2017
Updated on 20-Sep-2020
Manish Kumar
04-May-2017Sql statement are categoriesed into three types
DDL-Data definition language is use define the structure of database which holds the content or data.
Mainly it is used to define the structure that holds the data Example of DDL is Create,Alter,Drop and truncate.
DML-Data manipulation language is used to retrieve,store,modify,delete,insert and update data in database. Its operation is select,Update,Insert
DCL-Data Control Language is used to create roles, permission.It is used to control access to database by securing it.